# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2023年03月17日
"""
import openpyxl

myBook=openpyxl.load_workbook('层剪力.xlsx',data_only=True)
mySheet=myBook.active
print(mySheet)
for myRow in range(mySheet.max_row,1,-1):
	# print(mySheet[myRow][2].value)
	if mySheet[myRow][2].value is None:
		mySheet.delete_rows(myRow)
	if '(全部)' not in mySheet[myRow][2].value:
		mySheet.delete_rows(myRow)
myBook.save('结果表-层剪力表.xlsx')